﻿CREATE VIEW vw_PerformanceSample_Detailed
AS

Select A.PerformanceSampleRowId, C.DeploymentId, C.RoleRowId, C.RoleName, B.PerformanceCounterRowId, B.ObjectName, B.CounterName, B.InstanceName, A.InstanceNumber, A.DateTimeUTC, A.SampleValue
From PerformanceSample A with (nolock)
	Join PerformanceCounter B with (nolock)
		On A.PerformanceCounterRowId = B.PerformanceCounterRowId
	Join [Role] C with (nolock)
		On A.RoleRowId = C.RoleRowId